export const ResearcherQueries = {
    GetResearchers: `
    SELECT
      id,
      researcherName,
      employeeId,
      researcherPolitics,
      researcherEduBackground,
      researcherEduDegree,
      researcherSchool,
      researcherPhone,
      researcherMentorType,
      researcherSubject,
      researcherHonor,
      researcherOrganization,
      researcherField,
      researcherDirection,
      researcherOnjob
    FROM my_schema.researcher
    `,
  
    GetResearcherById: `
    SELECT
      id,
      researcherName,
      employeeId,
      researcherPolitics,
      researcherEduBackground,
      researcherEduDegree,
      researcherSchool,
      researcherPhone,
      researcherMentorType,
      researcherSubject,
      researcherHonor,
      researcherOrganization,
      researcherField,
      researcherDirection,
      researcherOnjob
    FROM my_schema.researcher
    WHERE
      id = ?
    `,

    AddResearcher: `
    INSERT INTO my_schema.researcher (id, researcherName, employeeId, researcherPolitics, researcherEduBackground, researcherEduDegree, researcherSchool, researcherPhone, researcherMentorType, researcherSubject, researcherHonor, researcherOrganization, researcherField, researcherDirection, researcherOnjob)
      VALUES ?
    `,

    UpdateResearcherById: `
    UPDATE my_schema.researcher
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteResearcherById: `
    DELETE FROM my_schema.researcher
    WHERE
      id = ?
    `
  };